2015-12-11 - 23589 - Service Request - Help Extracting Statistical Dates S032 #MasterData
Service Request
23589 - Help Extracting Statistical Dates S032
Problem Summary
Need to extract the most recent dates Date of Last receipt & Last consumption date from S032 Extractor based on Material & Plant.
Admin Info
Purpose
|
Need to extract the most recent dates Date of Last receipt & Last consumption date from S032 Extractor based on Material & Plant.
|
Requested by
|
Greg Jackson
|
Issue Date
|
12-11-2015
|
Resolved by
|
Damodhier
|
Resolved Date
|
12-21-2012
|
Document Status
|
Complete
|
Detailed Problem Description
Email From Greg Jackson on 12/1/2015:
Could use your help again. I have created an extractor to get the last consumption and last receipt date. The extractor is [ZDS_S032] and its loading to [0MAT_PLANT]. I am unable to figure out how to get both most recent dates at the same time when they are in the same extractor. I can easily sort the records and make one of the dates work and I could easily make two extractors and process them one at a time, for both dates to work. But two extractors for 1 field seems over the top and unneccessary. I have made a transformation and attempted it, and tried MANY combinations, but haven't had any luck. Is this how you would go about doing it or should we just have enhanced 0mat_plant extractor with the two dates? Any suggestions or help is appreciated!
Solution Analysis and Recommendations
Need to get recent dates of Date of last receipt & Last Consumption Date, the extractor is extracting the records, but not getting sorted out based on two dates simultaneously. To sort the records based on two dates, we need to develop the logic at start routine level, that extracted records should be sorted first on Material, Plant & Last Consumption date & Plant, Material & Last receipt date.
Resolution
1. Need to develop logic at the start routine for datasource ZDS_S032 to infoobject 0MAT_PLANT.
2. Need to sort the records first based on Material, Plant & Last Consumption date & then Plant, Material & Last receipt date.
3. Need to do unit testing in BPD.
Release Information
None